﻿<!DOCTYPE html>
<html>
	<head>
		<title>Clear text, format in a cell, copy cell format</title>
		<meta charset="utf-8" />
        <meta name="description" content="Clear the text or the format within your worksheet, copy cell format" />
		<link type="text/css" rel="stylesheet" href="../../../../../../common/main/resources/help/editor.css" />
		<link type = "text/css" rel = "stylesheet" href = "../../images/sprite.css" />
        <script type="text/javascript" src="../callback.js"></script>
        <script type="text/javascript" src="../search/js/page-search.js"></script>
	</head>
	<body>
		<div class="mainpart">
        <div class="search-field">
            <input id="search" class="searchBar" placeholder="Search" type="text" onkeypress="doSearch(event)">
        </div>
			<h1>Clear text, format in a cell, copy cell format</h1>
            <h3>Clear format</h3>
			<p>In the <a href="https://www.onlyoffice.com/spreadsheet-editor.aspx" target="_blank" onclick="onhyperlinkclick(this)"><b>Spreadsheet Editor</b></a>, you can quickly remove the text or format from the selected cell. To do that,</p>
			<ol>
				<li>select a cell, a cell range with the mouse or the whole worksheet by pressing the <b>Ctrl+A</b> key combination,
                <p class="note"><b>Note</b>: you can also select multiple non-adjacent cells or cell ranges holding down the <b>Ctrl</b> key while selecting cells/ranges with the mouse.</p>
                </li>
				<li>click the <b>Clear</b> <div class = "icon icon-clear"></div> icon on the <b>Home</b> tab of the top toolbar and select one of the available options:
				<ul>
				<li>use the <b>All</b> option if you wish to remove everything including the text, format, function etc;</li>
				<li>use the <b>Text</b> option if you wish to remove the text from the selected range of cell range;</li>
				<li>use the <b>Format</b> option if you wish to remove the format of the selected cell range. The text and all functions will remain;</li>
                <li>use the <b>Comments</b> option if you wish to remove comments from the selected cell range;</li>
                <li>use the <b>Hyperlinks</b> option if you wish to remove hyperlinks from the selected cell range.</li>
				</ul>
                <p class="note"><b>Note</b>: all these options are also available in the right-click menu.</p>
				</li>
			</ol>
            <h3>Copy cell format</h3>
            <p>You can quickly copy the format of a certain cell and apply it to other cells.</p>
            <p>To apply the copied format to a single cell or several adjacent cells,</p>
            <ol>
                <li>select the cell/cell range with the required format by clicking or <a href="../HelpfulHints/KeyboardShortcuts.htm#textselection" onclick="onhyperlinkclick(this)">using the keyboard</a>,</li>
                <li>click the <b>Copy style</b> <div class = "icon icon-copystyle"></div> icon on the <b>Home</b> tab of the top toolbar, (the mouse pointer will look like this <div class = "icon icon-paste_style"></div>),</li>
                <li>select the cell/cell range to apply the required format to.</li>
            </ol>
            <p>To apply the copied format to multiple non-adjacent cells or cell ranges,</p>
            <ol>
                <li>select the cell/cell range with the required format by clicking or <a href="../HelpfulHints/KeyboardShortcuts.htm#textselection" onclick="onhyperlinkclick(this)">using the keyboard</a>,</li>
                <li>double-click the <b>Copy style</b> <div class = "icon icon-copystyle"></div> icon on the <b>Home</b> tab of the top toolbar, (the mouse pointer will look like this <div class = "icon icon-paste_style"></div> and the <b>Copy style</b> icon will remain selected: <div class = "icon icon-copystyle_selected"></div>),</li>
                <li>click the required cells or select the cell ranges one by one to apply the same format to all of them,</li>
                <li>to exit this mode, click the <b>Copy style</b> <div class = "icon icon-copystyle_selected"></div> icon once again or press the <b>Esc</b> key on the keyboard.</li>
            </ol>
		</div>
	</body>
</html>
